﻿ IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'LineaDelete')
	BEGIN
		DROP  Procedure  LineaDelete
	END
GO

CREATE PROCEDURE LineaDelete
	(	
		@id		AS INT,
		@user	AS VARCHAR(30)
	)	
AS
BEGIN	
	SET NOCOUNT ON
	
	UPDATE Linea
	SET Activo = 0,
		FechaModificacion = GETDATE(),
		ModificadoPor = @user		
	WHERE LineaId = @id

	SET NOCOUNT OFF
END
GO 